How to: Insert fields on the Data Pane in Microsoft Query.

Solution:

Drag the field from the Table pane between other fields on the data pane, positioning it where it should be at the top of the data pane. Drop the field, and all other columns will move to the right when the field is dropped.